Introduction

Throughout our project, we will be referring to three datasets that we found through Kaggle. The first dataset analyzes the top 48 automakers’ daily stock prices, another specifically does deep analysis on Tesla stock alone, and the other does stock analysis on electric/gas car manufacturers. Our group will be mutating the top 48 automakers dataset to make it a bit more useful for investors who want to see if electric car manufacturers like Tesla or Lucid Motors are a worthy future investment or if they should stick with gas manufacturers like Ford and Audi. As it stands now, the dataset provides us with 48 automakers’ market cap, stock prices, and the country they originated from. While that information is very useful for investors, our group will be mutating the dataset to add more columns to make the dataset more helpful for investors. We will add columns that specify whether the automaker makes electric vehicles, gas vehicles, or both. Another column that will display if the stock for that automaker is either positive or negative for that day. For the Tesla-specific dataset, we will keep it in its original format because it gives us all the valuable information we need, like opening stock price for that day, closing stock price, stock high, stock low, and the number of units traded in a day. While being less specific, our last dataset gives us opening and closing stock prices from car manufacturers like Rolls Royce and Audi that produce not only gas cars but also electric cars. For our three graphs, we will have one that compares the stock prices of automakers based on the manufacturing country. Another graph comparing the stock prices of two of the top electric manufacturers (Tesla and Lucid Motors) over time. The last graph will show the fluctuation of Tesla stock prices daily. As we mentioned in our project proposal, the information from this dataset can serve useful for investors who want to invest in automakers—knowing important details like where the automakers make their cars, whether it is electric, gas, or both, and if the stock is up or down. More importantly, are electric automakers like Lucid Motors and Tesla the future of investments, or should investors still dump their money into the good old gas engine automakers? That is the goal we are trying to show through these datasets.

Summary Information

The dataset calculated 7 variables of data from 2956 different dates Tesla stock price was highest on 2021-11-04 at a price of 1243.48999 US dollars. From this dataset, Tesla stock has sold 9.256562^{10} units, which is an average of 3.1314486^{7} units per day. The largest jump in Tesla stock price was 100.380005 US dollars on 2022-02-24. The largest drop in Tesla stock price was -150.099976 US dollars on 2021-11-09. Tesla stock price increased the most in 2020 with a total price change of 634.377968 US dollars. Tesla stock price increased the least in 2011 with a total price change of 0.616. Tesla stock sold its most units in 2020 with a total of 1.9052912^{10} units. Tesla stock sold its least units in 2010 with a total of 1.0268455^{9} units.

Aggregate Table

The reason I choose this feature is that we want to figure out the relationship between countries, car brands, and the prices of their stocks. Therefore, we have to know how many countries in the dataset.

## country
##         Canada          China         France        Germany          India 
##              1             10              1              4              3 
##         Israel          Italy          Japan    Netherlands    South Korea 
##              1              1              7              1              3 
##         Sweden         Taiwan United Kingdom  United States 
##              1              1              2             12

Chart 1: Comparing Car Companies Linechart

This Line Chart compares Tesla’s stocks to different companies that are in direct competition with Tesla. Volkswagen is a leading, mainly gas car company while Lucid Motors is a rising electric car company. It shows Tesla’s stock to be exceedingly higher than the other two companies.

Chart 2: High vs Low Tesla Histogram

The histogram illustrates how much Tesla stock fluctuates on the daily. This graph is important for looking for days when Tesla does something positively or negatively that results in the stock price increasing or decreasing. There is no legend because the histogram only deals with one data type

Chart 3: Interactive Bubble Map of Average Stock Price by Country

This bubble map took the top 48 automakers in terms of market capital and grouped them by country to show which countries had the highest average stock price for auto makers. Tesla had the highest stock price of all the companies but the US did not have the highest price which shows that Tesla dominates other auto makers the US market.